﻿using System;
using System.Web;
using System.Collections;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;




namespace XYTXL.API
{
    public class JWGL_CX
    {
        public JWGL_CX()
        {

            //如果使用设计的组件，请取消注释以下行 
            //InitializeComponent(); 
        }

        /// <summary>
        /// 查询学生一次就业信息
        /// </summary>
        /// <param name="xh"></param>
        /// <returns></returns>
        public DataSet Firstwork(string xh)
        {

            SqlParameter[] parameters = new SqlParameter[4];
            parameters[0] = new SqlParameter("@_whfs", "查询学生一次就业信息");
            parameters[1] = new SqlParameter("@_xh", xh);
            parameters[2] = new SqlParameter("@_dm1", "");
            parameters[3] = new SqlParameter("@_dm2", "");
          
            DataSet dsmd = DbHelperSQL.RunProcedure("pr_xs_sele", parameters, "mytable");
            return dsmd;
        }

        /// <summary>
        /// 学生注册查询
        /// </summary>
        /// <param name="nj">学生年级</param>
        /// <param name="xm">学生姓名</param>
        /// <param name="txxm">学生同学姓名</param>
        /// <returns></returns>
        public DataSet Zcxx(string nj,string xm,string txxm)
        {

            SqlParameter[] parameters = new SqlParameter[4];
            parameters[0] = new SqlParameter("@_whfs", "查询学生注册权限");
            parameters[1] = new SqlParameter("@_xh", nj);
            parameters[2] = new SqlParameter("@_dm1", xm);
            parameters[3] = new SqlParameter("@_dm2", txxm);

            DataSet dsmd = DbHelperSQL.RunProcedure("pr_xs_sele", parameters, "mytable");
            return dsmd;
        }

      

        /// <summary>
        /// 班级情况统计
        /// 统计年级概况：whfs=“班级年级信息统计”，nj，xbdm均为空值
        /// 统计年级系部概况：whfs=“班级年级信息统计--年级”，nj传递选择的nj，xbdm为空值
        /// 统计年级系部班级概况：whfs=“班级年级信息统计--学院”，nj传递选择的nj，xbdm传递xbdm
        /// </summary>
        /// <param name="whfs"></param>
        /// <param name="nj"></param>
        /// <param name="xbdm"></param>
        /// <returns></returns>
        public DataSet Bjtj(string whfs,string nj,string xbdm)
        {

            SqlParameter[] parameters = new SqlParameter[4];
            parameters[0] = new SqlParameter("@_whfs",whfs);
            parameters[1] = new SqlParameter("@_xh", "");
            parameters[2] = new SqlParameter("@_dm1", nj);
            parameters[3] = new SqlParameter("@_dm2", xbdm);

            DataSet dsmd = DbHelperSQL.RunProcedure("pr_xs_sele", parameters, "mytable");
            return dsmd;
        }

        public DataSet Jzxx()
        {

            SqlParameter[] parameters = new SqlParameter[5];
            parameters[0] = new SqlParameter("@_whfs", "查询捐赠信息-显示前100条");
            parameters[1] = new SqlParameter("@_tablecode", "");
            parameters[2] = new SqlParameter("@_fieldslist", "");
            parameters[3] = new SqlParameter("@_query", "");
            parameters[4] = new SqlParameter("@_fs", "");
            DataSet dsxq = DbHelperSQL.RunProcedure("pr_zhcx", parameters, "mytable");

            //DataSet dsmd = DbHelperSQL.RunProcedure("pr_xs_sele", parameters, "mytable");
            return dsxq;

        }

        public DataSet Jzxxall()
        {

            SqlParameter[] parameters = new SqlParameter[5];
            parameters[0] = new SqlParameter("@_whfs", "查询捐赠信息");
            parameters[1] = new SqlParameter("@_tablecode", "");
            parameters[2] = new SqlParameter("@_fieldslist", "");
            parameters[3] = new SqlParameter("@_query", "");
            parameters[4] = new SqlParameter("@_fs", "");
            DataSet dsjzxx = DbHelperSQL.RunProcedure("pr_zhcx", parameters, "mytable");

            //DataSet dsmd = DbHelperSQL.RunProcedure("pr_xs_sele", parameters, "mytable");
            return dsjzxx;

        }

        public DataSet Jztj()
        {

            SqlParameter[] parameters = new SqlParameter[5];
            parameters[0] = new SqlParameter("@_whfs", "捐赠统计");
            parameters[1] = new SqlParameter("@_tablecode", "");
            parameters[2] = new SqlParameter("@_fieldslist", "");
            parameters[3] = new SqlParameter("@_query", "");
            parameters[4] = new SqlParameter("@_fs", "");
            DataSet dsjztj = DbHelperSQL.RunProcedure("pr_zhcx", parameters, "mytable");

            //DataSet dsmd = DbHelperSQL.RunProcedure("pr_xs_sele", parameters, "mytable");
            return dsjztj;

        }

    }

}